1. 测试数据导入

1.1. 下载MySQL开源测试数据

git clone https://github.com/datacharmer/test_db.git

1.2. 进入目录

1.3. 导入数据

• 超大的分区表

mysql -u root -p1234 < employees_partitioned.sql`

• 导入普通表

mysql < employees.sql

1.4. 测试是否成功导入

[root@dbserver test_db]# mysql -u root -p1234  -t < test_employees_sha.sql
mysql: [Warning] Using a password on the command line interface can be insecure.
+----------------------+
| INFO                 |
+----------------------+
| TESTING INSTALLATION |
+----------------------+
+--------------+------------------+------------------------------------------+
| table_name   | expected_records | expected_crc                             |
+--------------+------------------+------------------------------------------+
| employees    |           300024 | 4d4aa689914d8fd41db7e45c2168e7dcb9697359 |
| departments  |                9 | 4b315afa0e35ca6649df897b958345bcb3d2b764 |
| dept_manager |               24 | 9687a7d6f93ca8847388a42a6d8d93982a841c6c |
| dept_emp     |           331603 | d95ab9fe07df0865f592574b3b33b9c741d9fd1b |
| titles       |           443308 | d12d5f746b88f07e69b9e36675b6067abb01b60e |
| salaries     |          2844047 | b5a1785c27d75e33a4173aaa22ccf41ebd7d4a9f |
+--------------+------------------+------------------------------------------+

+--------------+------------------+------------------------------------------+
| table_name   | found_records    | found_crc                                |
+--------------+------------------+------------------------------------------+
| employees    |           300024 | 4d4aa689914d8fd41db7e45c2168e7dcb9697359 |
| departments  |                9 | 4b315afa0e35ca6649df897b958345bcb3d2b764 |
| dept_manager |               24 | 9687a7d6f93ca8847388a42a6d8d93982a841c6c |
| dept_emp     |           331603 | d95ab9fe07df0865f592574b3b33b9c741d9fd1b |
| titles       |           443308 | d12d5f746b88f07e69b9e36675b6067abb01b60e |
| salaries     |          2844047 | b5a1785c27d75e33a4173aaa22ccf41ebd7d4a9f |
+--------------+------------------+------------------------------------------+
+--------------+---------------+-----------+
| table_name   | records_match | crc_match |
+--------------+---------------+-----------+
| employees    | OK            | ok        |
| departments  | OK            | ok        |
| dept_manager | OK            | ok        |
| dept_emp     | OK            | ok        |
| titles       | OK            | ok        |
| salaries     | OK            | ok        |
+--------------+---------------+-----------+
+------------------+
| computation_time |
+------------------+
| 00:01:21         |
+------------------+
+---------+--------+
| summary | result |
+---------+--------+
| CRC     | OK     |
| count   | OK     |
+---------+--------+

1.5. 导入的模型关系图

@startuml

class current_dept_emp {
TABLE data
--
emp_no
dept_no
from_date
to_date
}
class dept_emp_latest_date{
TABLE data
--
emp_no
from_date
to_date
}
class dept_emp {
TABLE data
--
emp_no
dept_no
from_date
to_date
}

class departments {
TABLE data
--
dept_no
dept_name
}

class dept_manager {
TABLE data
--
emp_no
dept_no
from_date
to_date
}
class employees{
TABLE data
--
emp_no
birth_date
first_name
last_name
gender
hire_date
}


dept_emp .. dept_emp_latest_date
dept_emp }-- departments
dept_emp }-- employees
dept_manager }-- employees
dept_manager }-- departments
current_dept_emp .. dept_emp_latest_date
current_dept_emp .. dept_emp

class salaries{
TABLE data
--
emp_no
dept_no
from_date
to_date
}

class titles{
TABLE data
--
emp_no
title
from_date
to_date
}
@enduml